ALTER TABLE XJEquipment DROP COLUMN PlaceId
GO
ALTER TABLE XJEquipment DROP COLUMN ResourceId
GO
ALTER TABLE XJEquipment DROP COLUMN Describe
GO
ALTER TABLE XJEquipment DROP COLUMN Location
GO
ALTER TABLE XJEquipment DROP COLUMN ProductionDate
GO
ALTER TABLE XJEquipment DROP COLUMN Technician
GO
ALTER TABLE XJEquipment DROP COLUMN TechnicianContact
GO
ALTER TABLE XJEquipment DROP COLUMN DepartmentId
GO
ALTER TABLE XJEquipment ADD Specification nvarchar(50)
GO
ALTER TABLE XJEquipment ADD [Version] nvarchar(50)
GO
ALTER TABLE XJEquipmentStockLog DROP COLUMN ProductionDate
GO
ALTER TABLE XJEquipmentStockLog ADD Specification nvarchar(50)
GO
ALTER TABLE XJEquipmentStockLog ADD [Version] nvarchar(50)
GO
ALTER TABLE XJEquipmentStock DROP COLUMN ProductionDate
GO
ALTER TABLE XJEquipmentStock ADD Specification nvarchar(50)
GO
ALTER TABLE XJEquipmentStock ADD [Version] nvarchar(50)
GO
ALTER TABLE XJEquipmentStockInDetail DROP COLUMN ProductionDate
GO
ALTER TABLE XJEquipmentStockInDetail ADD Specification nvarchar(50)
GO
ALTER TABLE XJEquipmentStockInDetail ADD [Version] nvarchar(50)
GO
ALTER TABLE XJEquipmentStockOutDetail DROP COLUMN ProductionDate
GO
ALTER TABLE XJEquipmentStockOutDetail ADD Specification nvarchar(50)
GO
ALTER TABLE XJEquipmentStockOutDetail ADD [Version] nvarchar(50)
GO